package com.topisv.tms.repository.stock.check;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.stock.check.CheckPlanItem;

public abstract interface CheckPlanItemDao extends PagingAndSortingRepository<CheckPlanItem, Long>, JpaSpecificationExecutor<CheckPlanItem>
{

	@Query("select t from CheckPlanItem t where t.planCode=?")
	List<CheckPlanItem> loadByPlanCode(String planCode);

	@Query("select t from CheckPlanItem t where t.planCode=? and t.reverseFlag=?")
	List<CheckPlanItem> loadByCondition(String planCode, String reverseFlag);

}